<?
//设置需要搜索的表格的前缀后缀
$table_Suffix = $sys_term_table;
$table        = $table_Prefix . $table_Suffix;
$sort_by      = "nid";
$sort_order   = "desc";
//设置需要搜索的表格的排序项和升降项
?>


<?php

$query = mysql_query("SELECT COUNT(nid) FROM $table where interm = 'root' and belong ='brand' ");
$brand0num = mysql_result($query, 0);
 
 
$result = mysql_query("select * from $table where interm='root' and belong ='brand' order by $sort_by $sort_order");

while($row = mysql_fetch_array($result))
  {
  $brand0_nid[]=$row['nid'];
  $brand0_mid[]=$row['mid'];
  $brand0_name[]=$row['name'];


}
mysql_close($con);
?>








